Text File | 1996-03-01 | 861 b | 1 lines | [TEXT/ttxt]
<sql valarg 1>RANGE=0123456789-FORMAT=<H1>Error</H1>%%1v is not a valid value for Author ID</sql><sql valform PHONE>RANGE=0123456789- ()FORMAT=<H1>Error</H1>%%1v is not a valid value for Phone</sql><sql valform PCODE>RANGE=0123456789FORMAT=<H1>Error</H1>%%1v is not a valid value for Postcode</sql><sql init>SYBASE=/home1/sybase</sql><sql connect conn1>SERVER=SYBASEUSER=saPASS=</sql><sql execute conn1>set textsize 65536</sql><H1>Updating record for %[=FNAME%] %[=LNAME%]</H1>If no errors are shown below this line, the data was successfully updated<HR><sql execute conn1>update pubs..authorsset au_fname = '%['%[=FNAME%]%]', au_lname = '%['%[=LNAME%]%]', phone = '%['%[=PHONE%]%]', address = '%['%[=ADDRESS%]%]', city = '%['%[=CITY%]%]', state = '%['%[=STATE%]%]', zip = '%['%[=PCODE%]%]'where au_id = '%1a'</sql><sql disconnect conn1></sql><sql uninit></sql>
